3 visuals for webpage
This code will help produce the three visuals that are going to be a
part of each equity tracker indicator webpage: regional map (tract
level) of most recent data, chart of the most recent data, chart of
trends over time.
If the indicator is available through a tract-level data
set. Getting the data to a workable version may require some
data transformation. To explore, clean, transform, and generate a final
data set, please use the data-gen-tract-template. This script
will generate an .rda for the map and an .rda for the charts. These data
sets will be loaded in before the data visualization code.
Indicator Explanation
The cardiovascular disease mortality rate provides a way to
understand a population’s overall health. Cardiovascular disease can be
caused by diet, lack of exercise, smoking, and environmental risk
factors. Differences between groups of people can highlight differing
access to healthcare and public services, adequate nutrition, and living
conditions, all which impact a population’s susceptibility to
cardiovascular disease. For this measure, we are defining cardiovascular
disease mortality as an age-adjusted rate of deaths per 100,000 due to
cardiovascular disease, such as coronary heart disease, strokes, aortic
disease, and peripheral arterial disease.
1. Map of most recent data
To map data in this form, there should be a value corresponding to
each census tract. Depending on the year or source of the data, this
could be about 700 rows for data at the 2010 census tract resolution, or
about 900 rows for data at the 2020 census tract resolution.
Create Visual
Sources: Washington State Department of Health (DOH) 2016-20
Washington Tracking Network (WTN); U.S. Census Bureau, Geography
Division 2020 TIGER/Line Shapefiles
Data call outs
- 200: The region’s average cardiovascular disease mortality rate (per
100,000)
- 230: Pierce County has the highest rate of deaths due to heart
disease and stroke of PSRC’s four counties
- 770%: The rate is 770% higher in the census tract with the highest
rate (644), compared to the census tract with the lowest (74) rates
Insights & Analysis
- Kitsap County has the lowest cardiovascular disease mortality rate
(165 per 100,000), followed by Snohomish (179), King (199), and Pierce
(230)
- The census tracts with the lowest cardiovascular disease mortality
rate (per 100,000) are in West Seattle, King County (74); Bothell,
Snohomish County (74); Bryant/View Ridge neighborhoods (Seattle), King
County (78)
- The census tracts with the highest cardiovascular disease mortality
rate (per 100,000) are in the Auburn, King County (644); Kent, King
County (493); Lakewood, Pierce County (473)
2. Facet of most recent data
Create Visual
Cardiovascular Disease Mortality
Age adjusted rate per 100,000
Washington Tracking Network, Washington State Department of Health, U.S.
Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use
Microdata Sample (PUMS)
Data call outs
- 228: The cardiovascular disease mortality rate (per 100,000) for
people living in census tracts with the highest concentration of people
of color, 21% higher that in census tracts with the lowest
concentrations of people of color
- 16%: In Pierce County, the number of heart disease and
stroke-related deaths for areas with the highest concentration of low
income households is 16% higher than the regional average
- 36: When comparing areas with the highest and lowest concentrations
of limited English proficient households, King County has the largest
gap of 36 deaths or a 20% difference
Insights & Analysis
- The smallest difference in the cardiovascular disease mortality rate
between areas with higher numbers of households with lower income is in
King County (57 per 100,000), followed by Snohomish County (75), Pierce
County (77), and Kitsap County (93)
- The number of heart disease and stroke-related deaths is highest in
census tracts with the highest concentration of people with disabilities
in all the counties; however, the rate varies between 142 per 100,000 in
Kitsap County to 195 per 100,000 in Pierce County
- There is no noticeable relationship between heart disease and
stroke-related deaths and the concentration of people with limited
English proficiency
- Census tracts with higher concentrations of households with families
have higher rates of cardiovascular disease mortality in King and Pierce
Counties, while there is no clear trend in Kitsap and Snohomish
Counties
3. Facet of trend data
Create Visual
Cardiovascular Disease Mortality
Age adjusted rate per 100,000
Washington Tracking Network, Washington State Department of Health, U.S.
Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use
Microdata Sample (PUMS)
Data call outs
- 81%: The gap in the regional cardiovascular disease mortality rate
between census tracts with the highest and lowest concentrations of
people of color increased in 2020, an 81% larger rate than in 2010
- 70: The gap in the rate between census tracts with the highest and
lowest concentrations of households below 200% of the poverty line in
2020, a 9% decrease compared to 2010
- 164%: The gap in the number of heart disease and stroke-related
deaths between census tracts with the highest and lowest concentrations
of households with youth increased by 164% between 2010 and 2020
Insights & Analysis
- For census tracts with the highest concentration of people of color,
King County is the only county in the region where the cardiovascular
disease mortality increased over the past decade (7% increase)
- Although deaths related to heart disease and stroke have decreased
over time for census tracts with the highest concentration of households
below 200% of the poverty line in all counties, the rate has remained
the highest in Pierce County (279 per 100,000) - compared to King County
(233), Kitsap County (222), and Snohomish County (219)
- For census tracts with the highest concentration of people with
disabilities, Snohomish County is the only county in the region where
the cardiovascular disease mortality rate has decreased, or improved,
over time (-28 per 100,000), while the rate has slightly increased in
Pierce County (+4 per 100,000), King County (+10 per 100,000), and
Kitsap County (+11 per 100,000)